DATEARRAY

Element

Attributes

Attribute Value

Element Value

Definition

<MathVariable>

TYPE

DATEARRAY

OPERATION

CREATE

A variable whose value is the length of a newly created array.

A new array with the length equal to the element value and each value defaulting to the value of DEFAULT attribute.

COPY

Takes SOURCEARRAY attributes and creates a separate but identical list.

REPLACE

A variable or date literal to replace one or more of the elements of the current array.

The INDEX attribute will either have an index value or two index values separated by a comma. If INDEX contains only one value, the element at that index is replaced by the valued entered. If INDEX contains two values, the elements from the first index to and including the second index are replaced.

REMOVE

N/A

Results in an array identical to SOURCEARRAY with the element at INDEX removed.

APPEND

A variable or date literal whose value to be appended to array SOURCEARRAY.

Results in new array equal to array indicated by SOURCEARRAY attribute with element value appended.

INSERT

A variable or date literal whose value is to be inserted into an SELECTARRAY at INDEX

Results in new array equal to array indicated by SOURCEARRAY attribute with element value inserted at index indicated by INDEX attribute.

FILLBY-LIST

Comma separated list of date constants and/or variable names.

Fills the array with the values entered.

FILLBY-SQL

SQL select statement that selects date values from a single column from the database.

Fills the array with the values returned from SQL.

TRANSFORM

Any valid expression. If the array elements are to be updated by using their current value in the calculation, use the name of the array in place of that value. If the value is just the name of another array variable, then that array is copied.

Performs the indicated calculation where one or more of the variables used in the expression are arrays.

ARRAYFUNCTION

Any valid function call.

Executes a function.

EXPAND

Use the MULTIPLIER attribute to indicate the number of times each element of the original array should be duplicated. The first and last elements may have a different number of duplicates than the other elements, so this attribute's value can be a comma delimited list of, at most, three values. If only one value is supplied, the others are defaulted to that value.

Creates a new array by duplicating each element of the original array a given number of times.

SETMIN

A variable or date literal.

Results in new array in which each element is the smaller of the corresponding element from SOURCEARRAY and the numeric element value.

SETMAX

A variable or date literal.

Results in new array in which each element is the larger of the corresponding element from SOURCEARRAY and the numeric element value.

STRIDE

A variable or date literal.

Results in new array containing every nth element of the SOURCEARRAY attribute array where 'n' is the element value.